<h4>Tool</h4><table border="0"><tr><td valign="top"><b>Name</b></td><td valign="top">Execute SQL</td></tr><tr><td valign="top"><b>ID</b></td><td valign="top">3</td></tr><tr><td valign="top"><b>Author</b></td><td valign="top">O.Conrad (c) 2010</td></tr></table><hr><h4>Description</h4>Execute SQL commands on a connected ODBC source. Separate different commands with a semicolon (';'). <hr><h4>Parameters</h4><table border="1" width="100%" valign="top" cellpadding="5" rules="all"><tr><th>Name</th><th>Type</th><th>Identifier</th><th>Description</th><th>Constraints</th></tr>
<tr><th colspan="5">Options</th></tr><tr><td>DSN</td><td>Text</td><td>ODBC_DSN</td><td>Data Source Name</td><td></td></tr><tr><td>User</td><td>Text</td><td>ODBC_USR</td><td>User Name</td><td></td></tr><tr><td>Password</td><td>Text</td><td>ODBC_PWD</td><td>Password</td><td></td></tr><tr><td>SQL Statment</td><td>Long text</td><td>SQL</td><td></td><td>Default: CREATE TABLE myTable1 (Col1 VARCHAR(255) PRIMARY KEY, Col2 INTEGER);
INSERT INTO myTable1 (Col1, Col2) VALUES('First Value', 1);
DROP TABLE myTable1;
</td></tr><tr><td>Commit</td><td>Boolean</td><td>COMMIT</td><td></td><td>Default: 1</td></tr><tr><td>Stop on Error</td><td>Boolean</td><td>STOP</td><td></td><td>Default: 0</td></tr></table>